USE [CTEM-DB-v1]
GO

/****** Object:  StoredProcedure [dbo].[Employee_CreateAdvance]    Script Date: 02/10/2012 11:28:12 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		TienDH
-- Create date: 12/05/2011
-- Description:	Get full employee's information
-- =============================================
CREATE PROCEDURE [dbo].[Employee_CreateAdvance]	
	@EmployeeID		BIGINT,
	@TotalAdvance	BIGINT,
	@DateAdvance	DATETIME,
	@Reason			NVARCHAR(MAX),
	@Note			NVARCHAR(MAX),
	@Type			NVARCHAR(50)
AS
BEGIN	
	INSERT INTO Advance
			(EmployeeID, TotalAdvance, DateAdvance, Reason, Note, [Type])
	VALUES	(@EmployeeID, @TotalAdvance, @DateAdvance, @Reason, @Note, @Type)	
END

GO

